<script type="text/javascript">
    jQuery(document).ready(function () {
        jQuery('.show-map').click(function () {
            alert('<?php _e( 'To be added soon', 'wp-statistics' ); ?>');
        });

        postboxes.add_postbox_toggles(pagenow);
    });
</script>
<?php
$date_args     = '';
$daysToDisplay = 20;
if ( array_key_exists( 'hitdays', $_GET ) ) {
	$daysToDisplay = intval( esc_attr( $_GET['hitdays'] ) );
	$date_args     .= '&hitdays=' . $daysToDisplay;
}

if ( array_key_exists( 'rangestart', $_GET ) ) {
	$rangestart = esc_attr( $_GET['rangestart'] );
	$date_args  .= '&rangestart=' . $rangestart;
} else {
	$rangestart = '';
}

if ( array_key_exists( 'rangeend', $_GET ) ) {
	$rangeend  = esc_attr( $_GET['rangeend'] );
	$date_args .= '&rangeend=' . $rangeend;
} else {
	$rangeend = '';
}

list( $daysToDisplay, $rangestart_utime, $rangeend_utime ) = wp_statistics_date_range_calculator(
	$daysToDisplay,
	$rangestart,
	$rangeend
);

$rangestartdate = $WP_Statistics->real_current_date( 'Y-m-d', '-0', $rangestart_utime );
$rangeenddate   = $WP_Statistics->real_current_date( 'Y-m-d', '-0', $rangeend_utime );

if ( array_key_exists( 'phrase', $_GET ) ) {
	$phrase       = $_GET['phrase'];
	$title        = $_GET['phrase'];
	$referr_field = '&phrase=' . $phrase;
} else {
	$phrase       = '';
	$phrase_field = null;
}

$get_urls = array();
$total    = 0;

if ( $phrase ) {
	$q_string = $wpdb->prepare(
		"SELECT `words` , count(`words`) as `count` FROM `{$wpdb->prefix}statistics_search` WHERE `words` LIKE %s AND `words` <> '' AND `last_counter` BETWEEN %s AND %s GROUP BY `words` order by `count` DESC",
		'%' . $phrase . '%',
		$rangestartdate,
		$rangeenddate
	);
	$result   = $wpdb->get_results( $q_string );
	$total    = count( $result );
} else {
	$q_string = $wpdb->prepare(
		"SELECT `words` , count(`words`) as `count` FROM `{$wpdb->prefix}statistics_search` WHERE `words` <> '' AND `last_counter` BETWEEN %s AND %s GROUP BY `words` order by `count` DESC",
		$rangestartdate,
		$rangeenddate
	);
	$result   = $wpdb->get_results( $q_string );
	$total    = count( $result );
}

?>
<div class="wrap">
    <h2><?php _e( 'Top Searched Phrases', 'wp-statistics' ); ?></h2>
    <?php do_action( 'wp_statistics_after_title' ); ?>

    <div><?php wp_statistics_date_range_selector(
			WP_Statistics::$page['searched-phrases'],
			$daysToDisplay,
			null,
			null,
			$phrase_field
		); ?></div>

    <div class="clear"/>

    <ul class="subsubsub">
		<?php if ( $phrase ) { ?>
            <li class="all"><a <?php if ( ! $phrase ) {
					echo 'class="current"';
				} ?>href="?page=<?php echo WP_Statistics::$page['searched-phrases'] . $date_args; ?>"><?php _e(
						'All',
						'wp-statistics'
					); ?></a>
            </li>
            |
            <li>
                <a class="current"
                   href="?page=<?php echo WP_Statistics::$page['searched-phrases']; ?>&referr=<?php echo esc_html( $phrase ) .
				                                                                                         $date_args; ?>"> <?php echo htmlentities(
						$title,
						ENT_QUOTES
					); ?>
                    <span class="count">(<?php echo $total; ?>)</span></a></li>
		<?php } else { ?>
            <li class="all"><a <?php if ( ! $phrase ) {
					echo 'class="current"';
				} ?>href="?page=<?php echo WP_Statistics::$page['searched-phrases'] . $date_args; ?>"><?php _e(
						'All',
						'wp-statistics'
					); ?>
                    <span class="count">(<?php echo $total; ?>)</span></a></li>
		<?php } ?>
    </ul>
    <div class="postbox-container" id="last-log">
        <div class="metabox-holder">
            <div class="meta-box-sortables">
                <div class="postbox">
					<?php if ( $phrase ) {
						$paneltitle = sprintf( __( 'Searched Phrase: %s', 'wp-statistics' ), esc_html( $phrase ) );
					} else {
						$paneltitle = __( 'Top Searched Phrases', 'wp-statistics' );
					}; ?>
                    <button class="handlediv" type="button" aria-expanded="true">
						<span class="screen-reader-text"><?php printf(
								__( 'Toggle panel: %s', 'wp-statistics' ),
								$paneltitle
							); ?></span>
                        <span class="toggle-indicator" aria-hidden="true"></span>
                    </button>
                    <h2 class="hndle"><span><?php echo $paneltitle; ?></h2>

                    <div class="inside">
                        <div class="log-latest">
							<?php

							if ( $total > 0 ) {
								// Initiate pagination object with appropriate arguments
								$pagesPerSection = 10;
								$options         = array( 25, "All" );
								$stylePageOff    = "pageOff";
								$stylePageOn     = "pageOn";
								$styleErrors     = "paginationErrors";
								$styleSelect     = "paginationSelect";

								$Pagination = new WP_Statistics_Pagination(
									$total,
									$pagesPerSection,
									$options,
									false,
									$stylePageOff,
									$stylePageOn,
									$styleErrors,
									$styleSelect
								);

								$start = $Pagination->getEntryStart();
								$end   = $Pagination->getEntryEnd();

								if ( $result ) {
									$result = array_slice( $result, $start, $end );
									$i      = $start;
									foreach ( $result as $item ) {
										$i ++;
										echo "<div class='log-item'>";
										echo "<div class='log-referred'>{$i} - {$item->words}</div>";
										echo "<div class='clear'></div>";
										echo "<div class='log-url'>{$item->count}</div>";
										echo "</div>";
									}
								}
							}

							?>
                        </div>
                    </div>
                </div>

                <div class="pagination-log">
					<?php if ( $total > 0 ) {
						echo $Pagination->display(); ?>
                        <p id="result-log"><?php printf(
								__( 'Page %1$s of %2$s', 'wp-statistics' ),
								$Pagination->getCurrentPage(),
								$Pagination->getTotalPages()
							); ?></p>
					<?php } ?>
                </div>
            </div>
        </div>
    </div>
</div>